IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spEmployeesSelect')
	BEGIN
		DROP  PROCEDURE  spEmployeesSelect
	END
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- TEST: EXEC spEmployeesSelect
-- =============================================
CREATE PROCEDURE spEmployeesSelect
	
AS
BEGIN
	SELECT [EmployeeID]
      ,[LastName]
      ,[FirstName]
      ,[Title]
      ,[TitleOfCourtesy]
      ,[BirthDate]
      ,[HireDate]
      ,[Address]
      ,[City]
      ,[Region]
      ,[PostalCode]
      ,[Country]
      ,[HomePhone]
      ,[Extension]
      ,[Photo]
      ,[Notes]
      ,[ReportsTo]
      ,[PhotoPath]
  FROM [Employees]
END
GO
